using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
namespace Bussiness.Manager
{
                

    public class DMS028_SBL_VIEWManager:Bussiness.ManagerBase.DMS028_SBL_VIEWManagerBase
    {
            public static DMS028_SBL_VIEWManager CreateInstant()
            {
                return new DMS028_SBL_VIEWManager();
            }
            public DataTable GetByOrderNo(string orderNo)
            {
                string sql = @" 
                        select Part_Name_V as Name
                            ,QTY
                            ,Price_After_Discount as Price
                            ,QTY*Price_After_Discount as Amount  
                        from DMS028_SBL_VIEW 
                        where order_no in 
                            (select Order_No 
                             from DMS027
                             where RPO_NO='" + orderNo + "')";
                return SqlHelper.ExecuteDataTable(Config.ConnectionConfig.ConnectionString, CommandType.Text, sql);
            }
    }
}
                    
